Interview Questions

1. What SSIS feature enables you to use a different database connection string on a production server that is used during development?

Options:

a. Package Configurations

b. The SSIS .properties file

c. The Control Flow s configuration tab

d. Package Execution Profiles

Reveal Answer

2. What is the purpose of a package checkpoint?

Options:

a. Package checkpoints enable package restartability

b. If running the package in the debugger, package checkpoints stop package execution at the designated checkpoint

c. Package checkpoints allow you to roll-back package design changes to a previous version of the package

d. Package checkpoints are not a feature of SSIS packages

Reveal Answer

3. You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in staging tables in preparation for a data warehouse load. The package and all three Execute SQL product tasks have their Transaction Option property set to Supported. You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will roll back their changes. What should you do?

Options:

a. Change the Transaction Option property of the package to Required.

b. Change the Transaction Option property of all three Execute SQL product tasks to Required.

c. Move the three Execute SQL product tasks into a For each Loop container.

d. Move the three Execute SQL product tasks into a Sequence container.

Reveal Answer

4. For what data checkpoint data is not saved?

Options:

a. For Each Loop containers

b. For Loop containers.

c. While Loop Container

d. Sequence Container

Reveal Answer

5. Mention what are the possible locations to save SSIS package?

Options:

a. SQL Server

b. Package Store

c. File System

Reveal Answer

6. Parameters are how many types in SSIS?

Options:

a. 2

b. 4

c. 3

d. 6

Reveal Answer

7. Parameters allow you to assign values to properties within packages at the time of package execution?

Options:

a. True

b. False

Reveal Answer

8. You work as a database developer at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You have been asked to revise a SQL Server Integration Services (SSIS) package. The package only includes Execute SQL tasks. To make sure that, in the event of an Execute SQL task failing, changes made by all of the Execute SQL tasks is rolled back. To do this, you want to alter the transaction Option property of the package. Which of the following is the value that must be set for the TransactionOption property of the package?

Options:

a. NotSupported.

b. Supported.

c. NotRequired.

d. Required.

Reveal Answer

9. You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured to import data into a SQL Azure hosted data warehouse. You have decided to make use of the Environment Variable package configuration as part of your solution. Which of the following is TRUE with regards to the Environment Variable package configuration?

Options:

a. It stores the property path inside the package and the value outside the package

b. It stores both the property path and the value outside the package

c. It is used to fetch a value from a variable in a calling package

d. It is the most commonly used configuration type

Reveal Answer

Interview Questions and Answer

1. What SSIS feature enables you to use a different database connection string on a production server that is used during development?

2. What is the purpose of a package checkpoint?

4. For what data checkpoint data is not saved?

5. Mention what are the possible locations to save SSIS package?

6. Parameters are how many types in SSIS?

7. Parameters allow you to assign values to properties within packages at the time of package execution?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources